'Usage Dim instance As CalcIndexFunction Dim args() As Object Dim value As Object value = instance.Evaluate(args)
Parameters
- args
The args contains 2 - 4 items: array, row_num, [column_num], [Area_num].
Array is a range of cells or an array constant.
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
[Column_num] selects the column in array from which to return a value. If column_num is omitted, row_num is required.
[Area_num] selects a range in reference from which to return the intersection of row_num and column_num.